---
title: "SQL-PINE-01: Ineligibility period by ID"
summary: Retrieve a single provider ineligibility period by ID
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-08-21
library: SAIF.Business.View.Provider
reference_type: embedded
---

# SQL-PINE-01 Ineligibility period by ID

Retrieves a single `PROVIDER_INELIG_PERIOD` record by its surrogate key, returning the
start/termination dates, reason code, and owning provider location.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-PINE-01 |
| **Operation type** | Read |
| **Execution method** | Inline SQL (BOF criteria constant) |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsProviderIneligibilityPeriod` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` / `AfterRetrieve` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:IneligibilityPeriodID` | Input | Decimal | N/A | `PROVIDER_INELIG_PERIOD_SEQ_NUM` |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PROVIDER_INELIG_PERIOD](../database-tables.md#provider_inelig_period) | SELECT | `EFF_DATE`, `EXP_DATE`, `PROVIDER_INELIG_PERIOD_SEQ_NUM`, `PROVIDER_INELIG_REASON_CODE`, `PROVIDER_LOCATION_SEQ_NUM`, `UPDATE_DATE`, `UPDATE_NUM`, `UPDATE_USER` |

## Sample SQL

```sql
-- Ineligibility period by ID
SELECT
  PROVIDER_INELIG_PERIOD.EFF_DATE                       AS StartDate,
  PROVIDER_INELIG_PERIOD.EXP_DATE                       AS TerminationDate,
  PROVIDER_INELIG_PERIOD.PROVIDER_INELIG_PERIOD_SEQ_NUM AS IneligibilityPeriodID,
  PROVIDER_INELIG_PERIOD.PROVIDER_INELIG_REASON_CODE    AS IneligibilityReasonCode,
  PROVIDER_INELIG_PERIOD.PROVIDER_LOCATION_SEQ_NUM      AS ProviderLocationID,
  PROVIDER_INELIG_PERIOD.UPDATE_DATE                    AS UpdateDate,
  PROVIDER_INELIG_PERIOD.UPDATE_NUM                     AS UpdateNum,
  PROVIDER_INELIG_PERIOD.UPDATE_USER                    AS UpdateUser
FROM PROVIDER_INELIG_PERIOD
WHERE PROVIDER_INELIG_PERIOD.PROVIDER_INELIG_PERIOD_SEQ_NUM = :IneligibilityPeriodID
```

## Operations and processes
- [Load provider ineligibility periods](../operations/load-provider-ineligibility-periods.md)

## Business rules
- [BR-PINE-001: Open-ended ineligibility period](../business-rules.md#br-pine-001-ineligibility-periods-without-termination-default-to-date-maxvalue)
- [BR-DATE-001: Date-window effectiveness](../business-rules.md#br-date-001-dated-records-are-in-effect-within-their-date-window)

## Sources
- SAIF.Business.View.Provider/clsProviderIneligibilityPeriod.vb